package com.miyu.client1.dao;

import com.miyu.client1.pojo.UserTableEntity;
import com.miyu.client1.utils.baseDao.BaseDao;
import org.springframework.data.jpa.repository.JpaRepository;
import org.springframework.data.jpa.repository.Query;
import org.springframework.stereotype.Repository;

import java.util.List;

@Repository
public interface userDao extends BaseDao<UserTableEntity,String> {

    @Query(value = "select * from user_table ",nativeQuery = true)
    List<UserTableEntity> queryUser(String name);

    @Query(value = "select user_name,user_account from user_table  ",nativeQuery = true)
    List<Object> queryDataBySql();
}

